<color><param>0100,0100,0100</param>Hi there 


<bold>I have a relatively simple problem :  </bold> 


I have a field named "id" that has type "Auto-number" in an Access database  
table.   


I know there is no 'auto_number' type in PostgreSQL.  I know also, that 
SERIAL and SEQUENCE are workarounds for this problem, but I'm not sure 
how to make a field a SERIAL once its already created in the table.


I have tried making the DEFAULT value of field "id" set to SERIAL, but I get this 
error :

<color><param>FF00,0000,0000</param>PostgreSQL said: ERROR: Attribute 'serial' not found 
Your query: 
<bold>ALTER TABLE "names" ALTER "id" SET DEFAULT SERIAL</bold>


<bold><color><param>0000,0000,0000</param>This is my system : </bold> 


odbc driver version (on Win machine) : 7.01.00.04 Insight Distrib.  
(PSQLODBC.DLL) 


odbc driver version (on Red Hat machine) : postgresql-odbc-7.0.2-17.rpm 


postgre database version : postgresql-7.0.2.rpm 


error messages on screen : none. 


the commlog file : see attached file (psqlodbc.log) 



<color><param>0100,0100,0100</param>Suggestions, workarounds and prayers would be appreciated ! 


love 

rich handler 





